Learning Objectives

After completing this lesson, you'll be able to:

• Create points using addresses.
• Understand the limitations of geocoding services.

Video

Resources

• CulturalSpaces2016.csv
  • C:\FMEData\Resources\IntegrateSpatialData\CulturalSpaces2016.csv
• Complete workspace
  • C:\FMEData\Workspaces\IntegrateSpatialData\exercise-turn-coordinates-into-geometry-by-geocoding-addresses-complete.fmw

Introduction

Sometimes your dataset will only contain addresses without latitude/longitude data. To handle these kinds of situations, you can use the Geocoder transformer.

The following services are supported:

Some Geocoder services support "reverse geocoding," finding the nearest address given a coordinate. Note also that the exact address formatting that will give you the best chance of successfully geocoding will vary by service. Refer to the service's documentation and use an AttributeManager or other transformers to ensure you are giving the transformer an address format it expects.

Exercise

1) Open FME Workbench

Open FME Workbench (2024.2 or later).

Click Blank Workspace to start a new workspace.

2) Add CSV Reader

Click Readers > Add Reader and set Format to CSV (Comma-Separated Value).

Click the ellipsis button [...] and select the downloaded CulturalSpaces2016.csv dataset or paste in the URL.

Click OK.

3) Add a Geocoder

Add a Geocoder to the canvas connected to the CSV feature type.

The Geocoder is shipped as an FME package, meaning you can update it without necessarily needing to update your version of FME. Because it ships as a package, FME asks you to confirm you wish to install it when you try to add it. Click Install to proceed:

Sign up for a free Google Geocoder API and then paste the API key into the API Key parameter in the Geocoder parameters.

If you don't want to sign up, you can use the free OpenStreetMap geocoder.

Next, for Street Address, identify where the address is stored and select that attribute. For this example, the address is stored in ADDRESS.

Here's what the dialog will look like if you use Google:

Before running the translation, set the Rejected Feature Handling workspace parameter to Continue Translation. We need to do this because some of the cultural spaces don't have an address associated with them, so our translation will stop when the Geocoder rejects these features. To do this, in the Navigator Pane > Workspace Parameters > Translation > Rejected Feature Handling > Continue Translation. After running the translation, you will see the points in Visual Preview.

4) Run the Workspace

Run the workspace and inspect the results.

 The output of point features using any of the three methods. Stylized in FME Data Inspector using map tiles by Stamen Design, under CC-BY-3.0. Data by OpenStreetMap, under CC-BY-SA.